
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_Sanad_AccCode' AND object_id = OBJECT_ID('dbo.Sanad'))
BEGIN
    
    CREATE NONCLUSTERED INDEX [IX_Sanad_AccCode] ON [dbo].[Sanad] ([Acc_Code])
    INCLUDE ([BEDEH], [BESTAN]);
END

IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_Sanad_IdSanad' AND object_id = OBJECT_ID('dbo.Sanad'))
BEGIN
   
    CREATE NONCLUSTERED INDEX [IX_Sanad_IdSanad] ON [dbo].[Sanad] ([Id_Sanad])
    INCLUDE ([Acc_Code], [BEDEH], [BESTAN]);
END



IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_HeadS_TarikhUser' AND object_id = OBJECT_ID('dbo.HeadS'))
BEGIN
    
    CREATE NONCLUSTERED INDEX [IX_HeadS_TarikhUser] ON [dbo].[HeadS] ([Tarikh_User])
    INCLUDE ([Id_Sanad]);
END



IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_Account_AccCode_Level' AND object_id = OBJECT_ID('dbo.Account'))
BEGIN
  
    CREATE NONCLUSTERED INDEX [IX_Account_AccCode_Level] ON [dbo].[Account] ([Acc_Code], [Acc_Level])
    INCLUDE ([Acc_Name]);
END